﻿CREATE TABLE [dbo].[Student] (
    [StudentID]           INT            IDENTITY (1, 1) NOT NULL,
    [FirstName]           NVARCHAR (255) NOT NULL,
    [SecondName]          NVARCHAR (255) NULL,
    [Surname]             NVARCHAR (255) NOT NULL,
    [BirthDate]           DATE           NOT NULL,
    [BirthPlace]          NVARCHAR (255) NOT NULL,
    [BirthState]          NVARCHAR (255) NOT NULL,
    [Sex]                 TINYINT        NOT NULL,
    [FirstNameDiminutive] NVARCHAR (255) NOT NULL,
    [FirstNameGenitive]   NVARCHAR (255) NOT NULL,
    [Address_Street]      NVARCHAR (500) NULL,
    [Address_PostCode]    NVARCHAR (255) NULL,
    [Address_City]        NVARCHAR (255) NULL,
    [MotherName]          NVARCHAR (255) NULL,
    [MotherSurname]       NVARCHAR (255) NULL,
    [FatherName]          NVARCHAR (255) NULL,
    [FatherSurname]       NVARCHAR (255) NULL,
    [PaperNumber]         NVARCHAR (100) NULL,
    [CreateDate]          DATETIME       NULL,
    [UpdateDate]          DATETIME       NULL
);

